'

 Why is the quantity not saving when i run my save.php. \ufeffWhenever i submit or press enter it doesn\'t submit to the database.

prepare("SELECT user_id, \ufeffbranch FROM users WHERE username = ?");

$userQuery->bind_param("s", \ufeff$username);

$userQuery->execute();

$userResult = \ufeff$userQuery->get_result();

$userRow = \ufeff$userResult->fetch_assoc();

$userId = \ufeff$userRow[\'user_id\'];

$userBranch = \ufeff$userRow[\'branch\'];

$userLevel = \ufeff$_SESSION[\'level\']; // \ufeffFetch user level from session

foreach ($ids as $id) {

$sizes = \ufeff$_POST[\'size\'][$id] ?? [];

$sizesString = \ufeffimplode(\',\', \ufeff$sizes);

$quantity = \ufeff$_POST[\'quantity\'][$id] ?? 0;

$branch = \ufeff$userBranch; // \ufeffUse the branch from the user info

if ($userLevel == \'2\' || \ufeff$userLevel == \'3\') {

\ufeff // \ufeffUpdate only the quantity

$orderStmt = \ufeff$conn->prepare("

INSERT INTO `order` (branch, \ufeffuser_id, \ufeffitem_id, \ufeffquantity, size) \ufeff

VALUES (?, ?, ?, ?, ?)

ON DUPLICATE KEY UPDATE

quantity = \ufeffVALUES(quantity)

\ufeff ");

\ufeff } \ufeffelseif ($userLevel == \'1\') {

\ufeff // \ufeffUpdate only the size

$orderStmt = \ufeff$conn->prepare("

INSERT INTO `order` (branch, \ufeffuser_id, \ufeffitem_id, \ufeffquantity, size) \ufeff

VALUES (?, ?, ?, ?, ?)

ON DUPLICATE KEY UPDATE

size = \ufeffVALUES(size)

\ufeff ");

\ufeff } \ufeffelse {

\ufeff // \ufeffIf user level is not 1, 2, \ufeffor 3, \ufeffskip the operation

continue;

\ufeff }

$orderStmt->bind_param("siiis", \ufeff$branch, $userId, $id, \ufeff$quantity, $sizesString);

$orderStmt->execute();

\ufeff }

header("Location: order.php");

exit();

} \ufeffelse {

header("Location: order.php");

exit();

}

?>

Note: The 59 \ufeffwas manually inputted through mysql.